package com.qfjy.mapper;

import com.qfjy.entity.po.MeetingType;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface MeetingTypeMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(MeetingType record);

    int insertSelective(MeetingType record);

    MeetingType selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(MeetingType record);

    int updateByPrimaryKey(MeetingType record);

    /**
     * todo 查询所有有效的逻辑类别
     */
    @Select("select * from meeting_type where `status` = 1 order by sortnum")
    List<MeetingType> selectMeetingTypeListByStatus();
}
